CREATE TABLE [dbo].[TSX_BIZDATA_YXJL] (
    [GUID]              VARCHAR (50)   NOT NULL,
    [TRAINNUMBER]       VARCHAR (30)   NULL,
    [STARTTIME]         DATETIME       NULL,
    [ENDTIME]           DATETIME       NULL,
    [CCZS]              NVARCHAR (200) NULL,
    [XXNR]              NVARCHAR (500) NULL,
    [SCGJ_CC_CONTENT]   NVARCHAR (200) NULL,
    [SCGJ_TC_CONTENT]   NVARCHAR (200) NULL,
    [SCGJ_CC_SIGN]      NVARCHAR (100) NULL,
    [SCGJ_TC_SIGN]      NVARCHAR (100) NULL,
    [SCGJ_CC_SIGN_TIME] DATETIME       NULL,
    [SCGJ_TC_SIGN_TIME] DATETIME       NULL,
    [CZBP_CK_CONTENT]   NVARCHAR (200) NULL,
    [CZBP_RK_CONTENT]   NVARCHAR (200) NULL,
    [CZBP_CK_SIGN]      NVARCHAR (100) NULL,
    [CZBP_RK_SIGN]      NVARCHAR (100) NULL,
    [CZBP_CK_SIGN_TIME] DATETIME       NULL,
    [CZBP_RK_SIGN_TIME] DATETIME       NULL,
    [DDY_SIGN]          NVARCHAR (100) NULL,
    [DDY_SIGN_TIME]     DATETIME       NULL,
    [CWZD_SIGN]         NVARCHAR (100) NULL,
    [CWZD_SIGN_TIME]    DATETIME       NULL,
    [ZBSZ_SIGN]         NVARCHAR (100) NULL,
    [ZBSZ_SIGN_TIME]    DATETIME       NULL,
    [STATUS]            TINYINT        NULL,
    [OPERATOR_GUID]     VARCHAR (50)   NULL,
    PRIMARY KEY CLUSTERED ([GUID] ASC)
);

CREATE TABLE [dbo].[TSX_BIZDATA_YXJL_DMGZ] (
    [ID]              INT            IDENTITY (1, 1) NOT NULL,
    [PARENT_GUID]     VARCHAR (50)   NULL,
    [TRAIN_INDEX]     TINYINT        NULL,
    [GZQK]            NVARCHAR (500) NULL,
    [CLQK]            VARCHAR (500)  NULL,
    [TZGZQK]          VARCHAR (500)  NULL,
    [JCJXS_SIGN]      VARCHAR (100)  NULL,
    [JCJXS_SIGN_TIME] DATETIME       NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC)
);

CREATE TABLE [dbo].[TSX_BIZDATA_YXJL_JCGZ] (
    [ID]              INT            IDENTITY (1, 1) NOT NULL,
    [PARENT_GUID]     VARCHAR (50)   NULL,
    [TRAIN_INDEX]     TINYINT        NULL,
    [GZQK]            NVARCHAR (500) NULL,
    [CLQK]            VARCHAR (500)  NULL,
    [JCJXS_SIGN]      VARCHAR (100)  NULL,
    [JCJXS_SIGN_TIME] DATETIME       NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC)
);

CREATE TABLE [dbo].[TSX_BIZDATA_YXJL_RSGZ] (
    [ID]              INT            IDENTITY (1, 1) NOT NULL,
    [PARENT_GUID]     VARCHAR (50)   NULL,
    [TRAIN_INDEX]     TINYINT        NULL,
    [GZQK]            NVARCHAR (500) NULL,
    [FXSJ]            DATETIME       NULL,
    [FXZ]             NVARCHAR (50)  NULL,
    [CLQK]            VARCHAR (500)  NULL,
    [JXBZ_SIGN]       VARCHAR (100)  NULL,
    [JXBZ_SIGN_TIME]  DATETIME       NULL,
    [JCJXS_SIGN]      VARCHAR (100)  NULL,
    [JCJXS_SIGN_TIME] DATETIME       NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC)
);

CREATE TABLE [dbo].[TSX_BIZDATA_YXJL_YXJS] (
    [ID]             INT           IDENTITY (1, 1) NOT NULL,
    [PARENT_GUID]    VARCHAR (50)  NOT NULL,
    [CREATE_TIME]    DATETIME      NOT NULL,
    [OPERATOR_ID]    VARCHAR (50)  NULL,
    [TRAINNUM]       VARCHAR (30)  NOT NULL,
    [QD]             VARCHAR (50)  NULL,
    [YXJS]           VARCHAR (500) NULL,
    [SCJS_SIGN]      VARCHAR (100) NULL,
    [SCJS_SIGN_TIME] DATETIME      NULL,
    [LCZ_SIGN]       VARCHAR (100) NULL,
    [LCZ_SIGN_TIME]  DATETIME      NULL,
    [SJ_SIGN]        VARCHAR (100) NULL,
    [SJ_SIGN_TIME]   DATETIME      NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC)
);

CREATE TABLE [dbo].[TSX_BIZDATA_FILES] (
    [ID]          VARCHAR (50)   NOT NULL,
    [FILENAME]    NVARCHAR (200) NOT NULL,
    [SIZE]        INT            NOT NULL,
    [SAVEPATH]    NVARCHAR (255) NOT NULL,
    [CONTENTTYPE] VARCHAR (50)   NULL,
    [CREATETIME]  DATETIME       NOT NULL,
    [DEVICEID]    VARCHAR (50)   NULL,
    [DESCRIPTION] NVARCHAR (200) NULL,
    [STATUS]      TINYINT        DEFAULT ((0)) NOT NULL,
    [BIZTYPE]     VARCHAR (20)   NULL,
    [BIZTABLE]    VARCHAR (50)   NULL,
    [PARENT_GUID] VARCHAR (50)   NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC)
);

